---
title: "Deep Insight Into Open Source Databases"
date: 2022-05-03
authors: [Jagger]
tags: [insight]
image: ./oss-database.png
description: On this page, we will share with you many deep insights into open source databases, such as the database popularity, database contributors, coding vitality, community feedback and so on.  
keywords: [Open Source Database, tidb, top ranking, github, database, github archive, gitHub metrics]
---

import {CommonChart} from "../../src/components/CommonChart";
import ContributorsCharts from "../../src/components/ContributorsCharts";
const osdbGroup = [507775, 60246359, 17165658, 41986369, 16563587, 6838921, 108110, 166515022, 48833910, 156018, 50229487, 20089857, 5349565, 6934395, 6358188, 11008207, 19961085, 206444, 30753733, 105944401, 31006158, 99919302, 50874442, 84240850, 28738447, 44781140, 372536760, 13124802, 146459443, 28449431, 23418517, 206417, 9342529, 19257422, 196353673, 172104891, 402945349, 11225014, 2649214, 41349039, 114187903, 20587599, 19816070, 69400326, 927442, 24494032]

On this page, we will share with you many deep insights into open source databases, such as the database popularity, database contributors, coding vitality, community feedback and so on. 

We’ll also share the SQL commands that generate all these analytical results above each chart, so you can use them on your own on TiDB Cloud following this [10-minute tutorial](/blog/try-it-yourself/). 

<!--truncate-->

## Database Popularity

### The popularity trend in the past ten years

The chart below displays the accumulated number of stars open source databases gained respectively each year and their star growth trend during the past ten years.

<CommonChart
    chart='dynamic-stars'
    category='archive/2021/repo-racing-by-stars'
    formatSql={false}
    field='database'
/>

### Which databases experienced a popularity boom in 2021?

The chart below displays top 10 open source databases with the highest year-over-year growth rate of stars in 2021 alone.

<CommonChart
  chart='yoychart'
  category='archive/2021/repo-ranking-by-yoy-stars-growth'
  formatSql={false}
  field='database'
/>

### Which databases barely gained influence in 2021?

The chart below displays top 10 open source databases with the lowest year-over-year growth rate of stars in 2021 alone. 

<CommonChart
    chart='yoychart'
    category='archive/2021/repo-ranking-by-yoy-stars-growth-least'
    formatSql={false}
    field='database'
/>

### Which databases were the new favorites in 2021?

The chart below displays the top open source databases that gained the most stars in 2021. 

<CommonChart
  chart='barchart'
  category='archive/2021/repo-ranking-by-stars-growth'
  formatSql={false}
  categoryIndex='repo_name'
  valueIndex='stars'
  seriesName='Stars'
  field='database'
  n={10}
/>

### Which countries & regions favor databases the most? 

The map below describes the geographical distribution of database stargazers. The larger and darker the color spots on this map, the more database stargazers are distributed.

<CommonChart
  chart='worldmapchart'
  category='analyze-stars-map'
  formatSql={false}
  categoryIndex='country_or_area'
  valueIndex='count'
  seriesName='stargazers'
  effect={false}
  size={56}
  repoId={osdbGroup}
/>

### Which companies like databases the most?

The pie chart below describes which company those database stargazers work for and how many stargazers those companies employ.

<CommonChart
  chart='piechart'
  category='analyze-stars-company'
  formatSql={false}
  categoryIndex='company_name'
  valueIndex='stargazers'
  categoryType='owner'
  seriesName='Stargazers'
  repoId={osdbGroup}
/>

## Database contributors 

### Which countries & regions led the database contributions in 2021? 

The map below shows the geographic distribution of developers who pushed commits, resolved issues, or submitted pull requests to open source databases in 2021. The larger and darker the color spots on this map, the more database contributors were distributed.

<CommonChart
  chart='worldmapchart'
  category='archive/2021/country-ranking-by-contributions'
  formatSql={false}
  categoryIndex='country_code'
  seriesName='Contributions'
  valueIndex='contributions'
  field='database'
/>

### Which companies led the database contributions in 2021?

The chart below shows the employment distribution of developers who pushed commits, resolved issues, or submitted pull requests to open source databases in 2021.

<CommonChart
  chart='barchart'
  category='archive/2021/company-ranking-by-contributions'
  formatSql={false}
  categoryIndex='company'
  valueIndex='contributions'
  seriesName='Contributions'
  categoryType={false}
  field='database'
/>

### Who were the leading individual contributors in 2021?

The chart below lists 20 most active individual contributors to open source databases in 2021 based on how many pull requests they opened.

<CommonChart
  chart='barchart'
  category='archive/2021/repo-pr-creator-ranking-by-prs'
  formatSql={false}
  categoryIndex='actor_login'
  valueIndex='prs'
  categoryType='owner'
  seriesName='PRs'
  field='database'
  n={20}
/>

### When did developers contribute?

The heat map below describes the number of push events that occur at a particular point of time (UTC). For each day and hour, the colored boxes indicate the number of push events. The lighter the color, the fewer push events; the darker the color, the more push events. You can learn from this heat map what time is the busiest for contributors, and roughly conclude which country or region distributes the most contributors.


<CommonChart
  chart='heatmapchart'
  category='analyze-commits-time-distribution'
  xIndex='hour'
  yIndex='dayofweek'
  valueIndex='pushes'
  formatSql={false}
  repoId={osdbGroup}
/>

## Database coding vitality

### Which databases vibrantly maintained and updated itself in 2021?

The chart below displays top 10 open source databases that received the most pull requests in 2021 alone.

<CommonChart
  chart='barchart'
  category='archive/2021/repo-ranking-by-prs'
  formatSql={false}
  categoryIndex='repo_name'
  valueIndex='prs'
  seriesName='PRs'
  field='database'
  n={10}
/>

## Database user feedback 

### Which databases have the widest feedback sources?

The chart below displays the number of issue creators of leading open source databases each year and their growth trend during the past ten years.

<CommonChart
  chart='barchart'
  category='archive/2021/repo-ranking-by-issue-creators'
  formatSql={false}
  categoryIndex='repo_name'
  valueIndex='issue_creators'
  seriesName='Issue Creators'
  categoryType={false}
  field='database'
  n={10}
/>

### Which databases gave the fastest first response in 2021?

The bar chart below shows the median time each open source database needs to make its first response to an issue.

<CommonChart
  chart='barchart'
  category='archive/2021/repo-ranking-by-issue-open-to-first-respond'
  formatSql={false}
  categoryIndex='repo_name'
  valueIndex='days'
  seriesName='Days'
  categoryType={false}
  field='database'
  n={10}
/>

#### Which databases were the most efficient in feedback resolution in 2021?

The bar chart below shows the median time each open source database needs to close an issue.

<CommonChart
  chart='barchart'
  category='archive/2021/repo-ranking-by-issue-open-to-close'
  formatSql={false}
  categoryIndex='repo_name'
  valueIndex='days'
  seriesName='Days'
  categoryType={false}
  field='database'
  n={10}
/>

### Who gave the feedback in 2021?

The map below shows the geographical distribution of developers who submitted issues to open source databases. The larger and darker the color spots on this map, the more issue openers were distributed. 

<CommonChart
  chart='worldmapchart'
  category='analyze-issue-creators-map'
  formatSql={false}
  categoryIndex='country_or_area'
  valueIndex='count'
  seriesName='Issue openers'
  effect={false}
  size={56}
  repoId={osdbGroup}
/>

## Community Robustness

### Which databases have the most heavy contributors? 

The chart below displays the number of heavy contributors (who submitted more than 100 pull requests), medium contributors (who submitted more than 10 but less than 100 pull requests), and light contributors (who submitted less than 10 pull requests) of leading open source databases. The chart also ranks these databases based on their number of heavy contributors. 

<ContributorsCharts type='contributors' field='database'/>

### Which databases are heavily contributed?

The chart below displays the number of pull requests submitted by heavy contributors, medium contributors, and light contributors. The chart also ranks these databases based on the number of pull requests submitted by heavy contributors. 

<ContributorsCharts type='prs' field='database'/>

### How fast did databases approve their code changes?

The chart below shows the median time each open source database needs from submitting to merging a pull request.

<CommonChart
  chart='barchart'
  category='archive/2021/repo-ranking-by-pr-open-to-merge'
  formatSql={false}
  categoryIndex='repo_name'
  valueIndex='days'
  seriesName='Days'
  categoryType={false}
  field='database'
  n={20}
/>

## Database programming languages

### Which languages were most favored in 2021?

The chart below shows the top programming languages used in pull requests submitted to open source databases in 2021.

<CommonChart
    chart='barchart'
    category='archive/2021/language-ranking-by-prs'
    formatSql={false}
    categoryIndex='language'
    valueIndex='prs'
    categoryType='lang'
    seriesName='PRs'
    field='database'
/>